select uc.societe_uk_code, soc.libelle_societe, param.code_par_defaut_code,comgest.unite_gestion_uk_code from finplf.fi_par_unite_comptable uc 
inner join finplf.fi_par_societe soc on uc.societe_uk_code = soc.uk_code    
inner join finplf.fi_par_unite_comptable_gestion comgest on uc.id= comgest.unite_comptable_id
inner join finplf.fi_par_unite_gestion_plan pla on comgest.unite_gestion_uk_code = pla.unite_gestion_uk_code
inner join FINPLF.fi_par_plan_parametrage param on pla.plan_param_uk_code = param.uk_code

